Introduction

COVID-19 vaccination

Non-communicable diseases are the leading causes of death worldwide. Efforts are being made to understand the factors associated with these diseases with the aim of proposing effective public policies that contribute to their reduction.

Methodology

Problem: What is the status and factors associated with non-communicable diseases in Peruvian consumers?

Objective: To characterize the status and factors associated with non-communicable diseases in Peruvian consumers.

Target population: People over 15 years of age.

Data Base: INEI, Endes 2022

Measurement: Health and Household Questionnaire

Data preprocessing:

    1. Download modules 1640 and 1629 of the Demographic and Family Health Survey in csv format.
    1. Change commas to dots in the CSALUD01 and RECH0 DBs. SQL considers the dots as referring to decimals, the comma interprets it as a strange character. When you download the INEI database, the decimals are separated by commas. Modify it with notepad or another tool.

Results

1. Open pgAdmin 4

COVID-19 vaccination

2. Create a new database

COVID-19 vaccination

3. Name the project and save.

COVID-19 vaccination

4. We will have the database created.

COVID-19 vaccination

5. We will open a Query Tool

COVID-19 vaccination

6. Now we will open the attached file

COVID-19 vaccination

7. You can see the document ProyectoQuery.sql

COVID-19 vaccination

8. Now we can read the data in postgreSQL

COVID-19 vaccination

Conclusion

It is possible to analyze INEI databases using PostgreSQL.